home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freelog Special Freeware 31
/
FreelogHS31.iso
/
ArgentCompta
/
FASTCAISSE
/
Setup FASTCAISSE.exe
/
{app}
/
Initbase.sql
< prev
next >
Wrap
Text File
|
2007-06-05
|
3KB
|
37 lines
SET GENERATOR VERSION_BASE TO 76;
SET GENERATOR GENPK_BLOBS TO 5;
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (10000, 1, 0, 0, 'En compte');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (20000, 2, 0, 0, 'Grossiste');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (30000, 3, 0, 0, 'PTT');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (40000, 4, 0, 0, 'ENLEVEMENT SUR PLACE');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (70000, 7, 0, 0, 'Mr');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (70100, 7, 1, 0, 'Mme');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (70200, 7, 2, 0, 'Mlle');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (70300, 7, 3, 0, 'SociΘtΘ');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (70400, 7, 4, 0, 'SA');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (80000, 8, 0, 0, 'BANQUE DE FRANCE');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (90000, 9, 0, 0, '5,50');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (90100, 9, 1, 0, '19,60');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (100000, 10, 0, 0, 'T.T.C');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (100100, 10, 1, 0, 'H.T');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (100200, 10, 2, 0, 'Forcer TVA α 5,5');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (100300, 10, 3, 0, 'EXPORT');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (100400, 10, 4, 0, 'C.E.E');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (110000, 11, 0, 0, 'FRANCE');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (120000, 12, 0, 0, 'COMPTANT');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (120100, 12, 1, 0, '30 J');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (200000, 20, 0, 0, 'GRILLE 1');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (200100, 20, 1, 0, 'GRILLE 2');
INSERT INTO "CHAINES" ("PKEY", "TYPEC", "LIGNE", "COLONNE", "DESIGNATION") VALUES (200200, 20, 2, 0, '0@4');
INSERT INTO "CLIENTS" ("NOM") VALUES ('<Inconnu>');
INSERT INTO "FOURNISSEURS" ("NOM") VALUES ('<Inconnu>');
INSERT INTO "RAYONS" ("PKEY", "RY1", "RY2", "RY3", "NOMRAYON") VALUES (0, 0, 0, 0, 'Non classΘs');
INSERT INTO "BLOBS" (INDX,TEXTE) VALUES (1,null);
INSERT INTO "LANGUES" (INDX,PAYS,NOM,DEVISE1,DEVISE2,TAUX) VALUES (1,'FR','Franτais','Ç','Fr',6.55957);
INSERT INTO "ARTICLES" ("TVA") VALUES (1960);
INSERT INTO "DESIGNATIONS" ("INDXART","CODELANGUE","TEXTE") VALUES (1,1,'<Inconnu>');
INSERT INTO "TVA" ("TAUX", "EST_DEFAUT", "LISTE_RED", "LIBELLE", "CPTACHAT", "CPTVENTE") VALUES (550, 0, 1, 'Taux rΘduit', '445660', '445710');
INSERT INTO "TVA" ("TAUX", "EST_DEFAUT", "LISTE_RED", "LIBELLE", "CPTACHAT", "CPTVENTE") VALUES (1960, 1, 0, 'Tva α taux normal', '445660', '445710');